Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$SESSION_LONGOPS

This view displays the status of various operations that run for longer than 6 seconds (in absolute time). These operations currently include many backup and recovery functions, statistics gathering, and query execution, and more operations are added for every Oracle release.

To monitor query execution progress, you must be using the cost-based optimizer and you must:

- Set the `TIMED_STATISTICS` or `SQL_TRACE` parameter to `true`

- Gather statistics for your objects with the `ANALYZE` statement or the `DBMS_STATS` package

You can add information to this view about application-specific long-running operations by using the `DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS` procedure.

See Also: Oracle Database PL/SQL Packages and Types Reference for more information on `DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS`

Column | Datatype | Description
--- | --- | ---
`SID` | `NUMBER` | Session identifier
`SERIAL#` | `NUMBER` | Session serial number
`OPNAME` | `VARCHAR2(64)` | Brief description of the operation
`TARGET` | `VARCHAR2(64)` | The object on which the operation is carried out
`TARGET_DESC` | `VARCHAR2(32)` | Description of the target
`SOFAR` | `NUMBER` | The units of work done so far
`TOTALWORK` | `NUMBER` | The total units of work
`UNITS` | `VARCHAR2(32)` | The units of measurement
`START_TIME` | `DATE` | The starting time of operation
`LAST_UPDATE_TIME` | `DATE` | Time when statistics last updated
`TIMESTAMP` | `DATE` | Timestamp
`TIME_REMAINING` | `NUMBER` | Estimate (in seconds) of time remaining for the operation to complete
`ELAPSED_SECONDS` | `NUMBER` | The number of elapsed seconds from the start of operations
`CONTEXT` | `NUMBER` | Context
`MESSAGE` | `VARCHAR2(512)` | Statistics summary message
`USERNAME` | `VARCHAR2(30)` | User ID of the user performing the operation
`SQL_ADDRESS` | `RAW(4 | 8)` | Used with the value of the `SQL_HASH_VALUE` column to identify the SQL statement associated with the operation
`SQL_HASH_VALUE` | `NUMBER` | Used with the value of the `SQL_ADDRESS` column to identify the SQL statement associated with the operation
`SQL_ID` | `VARCHAR2(13)` | SQL identifier of the SQL statement associated with the operation
`QCSID` | `NUMBER` | Session identifier of the parallel coordinator